CREATE TABLE [dbo].[tb_Examenes]
(
[idExamen] [int] NOT NULL IDENTITY(1, 1),
[Organizacion] [int] NOT NULL,
[Descripcion] [int] NOT NULL,
[TipoExamen] [int] NOT NULL,
[FechaExamen] [datetime] NULL,
[HorarioDesde] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HorarioHasta] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Lugar] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[tb_Examenes] ADD CONSTRAINT [PK_tb_Examenes] PRIMARY KEY NONCLUSTERED  ([idExamen]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[tb_Examenes] WITH NOCHECK ADD CONSTRAINT [FK_tb_Examenes_tb_Organizaciones] FOREIGN KEY ([Organizacion]) REFERENCES [dbo].[tb_Organizaciones] ([idOrganizaciones])
GO
ALTER TABLE [dbo].[tb_Examenes] ADD CONSTRAINT [FK_tb_Examenes_tb_TiposDeExamen] FOREIGN KEY ([TipoExamen]) REFERENCES [dbo].[tb_TiposDeExamen] ([idTipoExamen])
GO
